Page 83 - Data_Science_Part_A C12

C. Competency-based/Application-based questions. 21 st Century #Technology Literacy
Skills
Harshit is not very comfortable while working in Excel. Suggest to which the appropriate feature that he can use to do his
work in Excel.

i. Type Employee id of 50 employees sequentially.
ii. Show sales of each salesman graphically.
iii. Calculate total sales

Previous Years’ Questions

1. In a spreadsheet software, an arrangement of cells in a vertical manner is known as: [2023]
a. Worksheets b. Workbooks
c. Rows d. Columns
Ans. d. Columns

2. Which of the following is not an example of a spreadsheet? [2023]
a. Microsoft Excel b. LibreOffice Calc
c. LibreOffice Impress d. Google Sheets

Ans. c. LibreOffice Impress
3. Differentiate between a row and a cell of a spreadsheet. [2023]
Ans. Row: A row is an arrangement of cells in a horizontal manner.
(or)
A row is a complete record
Cell: A cell is a rectangle shaped box, where the row and column meet. In cell we can enter text, numbers, date,
formula, etc. The cell that is selected appears highlighted.
(or)
A cell is an individual unit / item/ box presents in a spreadsheet.
4. When a cell address is referred to in a formula, it is called . [2022]
a. Cell referencing b. Naming
c. Range d. Operators
Ans. a. Cell referencing
5. Which option will you use to change the colour of the text? [2021]
a. Font Color b. Font
c. Highlight Color d. Format
Ans. a. Font Color

21 st Century #Creativity
Skills
Lab Activity

1. Create your mid-term report card in spreadsheet software. Use different fonts and colours to highlight
the totals and percentage.
2. Create a presentation on 'Positives of Covid Pandemic for India'.

ICT Skills-III 81